ORSANCO Notes
These are my persional notes about the current state of ORSANCO
Current status
- I am having an issue with the ORSANCO where the upserts in the riverflow and dailyriverflow tables are taking too long. 30 min per HDF file.
- Django is not creating Hypertables and are hopeful that Timescale will speed up the inserts.
- Sudhir is going to do some research on Timescale DB and talk it over with Jake. Until then ORSANCO is put on hold.
- The bucket query does not appear to require the tables to be hypertables as that query is working.
- It is likely that we will have to create a new database due to the issues we are having trying to create a hypertable with data already populated.
- If we do have to create a new database, then Jake is suggests getting rid of the current migrations and creating new migrations.
- We would immediately create 2 new migrations:
- The first would be adding the Timescale DB extension.
- The second would be to convert the riverflow and dailyriverflow tables to hypertables.
- If we do have to create a new database, then Jake is suggests getting rid of the current migrations and creating new migrations.